Upgrade Process

1. On clicking the upgrade button a confirmation is displayed asking the user to take a database backup in case of failures.

Important: Though this version of upgrade utility support roll back capability of schema and data with some limitations specified in the last section of document, it is highly recommended to take back up of database before proceeding with the upgrade.

2. After giving confirmation, the upgrade process gets started and the below screen is displayed till the execution starts

When the process starts, new row will get added to AsSystemVersion table with completed 'N' status. After completion the status for the respective version upgrade updates to 'Y'. This continues till the final upgraded version.

Another table AsUpgradeModule inserts entries for all the executed modules.

A new entry is added to table "upgradeprocess" ( This is a newly introduced table and will get created during Upgrade Utility application start up. It keeps track of current state of upgrade process). Here status and completed GMT have null entries initially.

Below are the possible status column values

• UPGRADECOMPLETED: This status is updated when the upgrade operation has been successfully completed.

• UPGRADEFAILED : This status is updated when the upgrade operation fails during execution.

• ROLLBACKCOMPLETED: This status is updated following the successful completion of a rollback operation after an upgrade failure.

• ROLLBACKFAILED: This status is updated when a rollback operation fails to complete.

3. After the initial start of upgrade process the below page gets rendered

Here in the left table section the status gets updated accordingly if the module is executed successfully or not . In the below case as the module got executed it is green tick icon in the status column of the module. Upgrade button gets disabled.

 

On the right side, there is a pie chart visualisation the progress of the module execution. The chart has two sections: "Remaining %" (in beige) and "Completed %" (in green).

 

In the below screen we can see total number of modules are 44 , executed modules are for now 6 and remaining to be executed are 38.

The log and report button get enabled and upon clicking the button it gives the log and report details for each module

4. If the upgrade gets executed successfully a popup is displayed stating that the upgrade is successful. In right half of the page it shows all the modules are executed

5. Upon clicking the OK button it refreshes the page and updates the current version as shown in the below screenshot.

System version is stating as completed.

The upgradeprocess table entry will also get updated with the status "UPGRADECOMPLETED".